This file contains instructions for for replicating empirical results in the following article submitted to Foreign Policy Analysis:

Title:The Power of Knowledge: How Think Tanks Impact US Foreign Policy.
Authors: Zaytsev, D., Kuskova, V., and Kononova, A.

Contact author: Dmitry Zaytsev, zaytsevdi2@gmail.com

Most of the study was based on qualitative methodology. 
Some data were collected google search engine; collection procedures are outlined in the article.
Results of these procedures, turned into tables and figures, are provided in the file (TTinFPA.xlsx).

In addition, to produce Table 3 of the article (mentions of US presidents in biographies of think tank experts),
data were collected by scraping think tank web pages and processed using Python. 
Detailed explanations of the steps required to generate Table 3 are provided below for replication purposes. 

Replication materials in this submission consist of the following files.

1. Excel file, TTinFPA.xlsx with data to reproduce graphs of the article:
1) Sheet 1 - Figure 1
2) Sheet 2 - Table 2
3) Sheet 3 - Figure 2

2. Archive Table3.7z contains Repr_Export folder with all the necessary data and files to reproduce Table 3:
1) .ipynb_checkpoints working file for Python (do not modify - used by the script)
2) IN - data used for processing
3) OUT - results of the code runnning
4) BuildNameNetworks.ipynb - script used to generate results out of data files
5) BuildNameNetworks.html - log of authors' own reproduction of the provided code in html format
6) BuildNameNetworks.pdf - log of authors' own reproduction of the provided code in pdf format
7) README.txt - a separate set of instructions for using the files and the code in the archive to generate obtained results
Archive also contains "Politicians_To_Centers_Matrix_NER2.xlsx" file, which shows how the result of the code, polit_center_matrix.xlsx
was turned into Table 3.

3. Excel file, TTinFPA_App.xlsx for data in the Appendix:
1) Sheet 1 - "Original and pivot" - original data from the Global Go To Think Tank Index and pivot of that data
2) Sheet 2 - Table 1A
3) Sheet 3 -  Table 2A
4) Sheet 4 - Table 3A
5) Sheet 5 - Table 4A

The rest of the tables in the article contained results of qualitative analysis that cannot be reproduced with analytic instruments
